1
Read the Four Maintenance Requests
DSAI2202 Lab 4: Maintaining Data
00:00

The UniLearn registry receives four maintenance requests. The goal is to change the intended data without affecting any other rows.

The Four Requests

  1. Add S106, Faisal Khan as DSAI, year 1, active, using the supplied email.
  2. Change only S103's email.
  3. Standardise Data Science to DSAI.
  4. Remove the incorrect test record S999.

The Safety Question

For every request, identify the operation, exact target, before and after state, and expected affected row count.

💡 Teaching Focus
A correct statement changes only the intended state.